[dbo].[EventSetupQuestionChoice]

Property	Value
Created	10:31:20 AM Tuesday, March 02, 2010
Last Modified	11:40:02 AM Monday, February 20, 2012

Property

Value

Created

10:31:20 AM Tuesday, March 02, 2010

Last Modified

11:40:02 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_EventSetupQuestionChoice: EventSetupQuestionChoiceID\EventSetupQuestionID$	EventSetupQuestionChoiceID	varchar(8)	8
$Cluster Primary Key PK_EventSetupQuestionChoice: EventSetupQuestionChoiceID\EventSetupQuestionID$	EventSetupQuestionID	int	4
	Answer	varchar(64)	64

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_EventSetupQuestionChoice: EventSetupQuestionChoiceID\EventSetupQuestionID$

EventSetupQuestionChoiceID

varchar(8)

$Cluster Primary Key PK_EventSetupQuestionChoice: EventSetupQuestionChoiceID\EventSetupQuestionID$

EventSetupQuestionID

int

Answer

varchar(64)

	Name	Columns	Unique
$Cluster Primary Key PK_EventSetupQuestionChoice: EventSetupQuestionChoiceID\EventSetupQuestionID$	PK_EventSetupQuestionChoice	EventSetupQuestionChoiceID, EventSetupQuestionID

Name

Columns

Unique

$Cluster Primary Key PK_EventSetupQuestionChoice: EventSetupQuestionChoiceID\EventSetupQuestionID$

PK_EventSetupQuestionChoice

EventSetupQuestionChoiceID, EventSetupQuestionID

Name	Columns
FK_EventSetupQuestionChoice_EventSetupQuestion	EventSetupQuestionID->[dbo].[EventSetupQuestion].[EventSetupQuestionID]

Name

Columns

FK_EventSetupQuestionChoice_EventSetupQuestion

EventSetupQuestionID->[dbo].[EventSetupQuestion].[EventSetupQuestionID]

SQL Script

CREATE TABLE [dbo].[EventSetupQuestionChoice]
(
[EventSetupQuestionChoiceID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EventSetupQuestionID] [int] NOT NULL,
[Answer] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[EventSetupQuestionChoice] ADD CONSTRAINT [PK_EventSetupQuestionChoice] PRIMARY KEY CLUSTERED ([EventSetupQuestionChoiceID], [EventSetupQuestionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[EventSetupQuestionChoice] ADD CONSTRAINT [FK_EventSetupQuestionChoice_EventSetupQuestion] FOREIGN KEY ([EventSetupQuestionID]) REFERENCES [dbo].[EventSetupQuestion] ([EventSetupQuestionID])
GO